package com.bwie.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.bwie.pojo.First;
import com.bwie.pojo.Scend;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author DarkClown
 * @date 2024-07-23 09:46
 * @project_name week0723
 * @parem
 **/
@Mapper
public interface ScenMapper extends BaseMapper<Scend> {
    @Select("select * from scend s left join first f on s.fir_id = f.fir_id")
    List<Scend> selectScen(Page<Scend> page, QueryWrapper<Scend> queryWrapper);

    @Delete("delete from first where fir_id = #{id}")
    void deleteFormFirst(Integer id);

    @Select("select * from first ")
    List<First> FirList();

    @Select("select * from first where fir_id = #{firId}")
    First selectFirst(Integer firId);


}
